1. Info

Noah developed an Android app in his CSE350 class final project to help people who are struggling with depression.

This project consists of three parts:

• Android app: Depression_App.apk (408 KB), Source code: Noah_Depression.zip (28.8 MB)
• PHP webserver: index.php (11 KB)
• MySQL database: depression_database.sql (4 KB)

The Android app will communicate with the PHP server and the PHP server will operate the MySQL database.

PS: I have setup his "PHP server" and "MySQL database" on carina. If you only want to run his app, just download Depression_App.apk and install on an Android device.

Account for testing:

• Username: noak
• passwor: n

2. Modify his code

I recommand you to use MAMP during the process of developing.
Here are some tips if you want to modify his code:

• For Android code, please check all *.java files to make sure that all IP addresses are correct. (He did not organize his project.)
• Change the index.php file to add/remove functions to operate MySQL database. (If you are going to deploy this on carina, please ask Prof. Chuah to get the password of MySQL. Again, he did not organize his code, so you need to change all passwords in this file.)

3. Deploy his project on carina

After you modified his code, if you need to deploy this on carina.

• Upload your [index.php] to [carina:/var/www/html/Depression]. Make sure all passwords in index.php are correct.
• Make sure all URLs in your Android project are correct.
• If you chagned MySQL, you can use this command to import your MySQL database:

  mysql -u root -p < depression_database.sql
  

Refer this tutorial for more details about how to develop an Android app which integrates PHP and MySQL.

Next: 7. Caleb_Storytelling, Previous: 5. Trained Boat classifier, Up: Index